Lookup multiple values on different sheet

Hi

You will have to change the number format for cells F10 and G10 from text to general. Select the cells, Format, Cells, Number, General then save.

Once you have changed the formats, you will have to edit and resave the formulas in the cells. So pick F10, press the F2 key, then press enter. Formula should then calculate.

HTH

rylo

yes, that works. Thank you so much. How do i give positive feed back for you? Thank you again