I have a spreadsheet that I am lost if ifs a Vlookup function or different formula,
In sheet1 on the K column I want to write a number that's affiliated with a specific code from the numbers and texts that are on sheet2, so if I put "1100" on K2, I want L2 to be filled with the appropriate text for that code.
Also is it possible to write depending on the code I entered on K2, to write "YES" or "NO" on M2 and color code it depending on the answer?
i.e:
K2: I'll enter "1100", then on L2 will write "LAE -tires" (coming from B2 on sheet2) then on M2 write NO and color code that cell in blue.
So I tried Vlookup but I can only write the text part but the number will disappear and to write YES or NO part was out of my knowledge .
Did I make sense?
Bookmarks