Watched the youtube tutorial and I am still missing something with my nested Vlookup as it returns #N/A. Assessment and Delcopurchases sheets.
First Vlookup returns the correct value and is in cell R10:
=VLOOKUP(StartPage!E6,Clients!A4:B257,2,FALSE)
2nd Vlookup is not working - #N/A
=VLOOKUP("R10",DelcoPurchases!$B$4:$E$581,3,FALSE)
R10: XYZ Shop
XYZ Shop (14x) in column B173:B186
3rd column is: AC Bearings
Ugg - im going mad. Let me understand this part and then I have a 2nd question
Thank you.