Forum Discussion
VLOOKUP formula not working for all cells
i have select cells from my lookup that are not being brought over as they should be. i have attached scheen shots of the issue. the blue and white page is where it pulls to and the white page is whe...
Most probably B17 is text and related value in first sheet is number; or opposite. You may check by ISTEXT(). Depends on that you need to transform one or another.
Does 4th parameter of Vlookup cause this? Will it might be duplicated items in sheet1 columnA?
- did a search and none of the numbers causing the issue are duplicated
Oops, I missed that. Yes, 4th parameter for VLOOKUP() defines approximate or exact search. If missed, that's approximate search. Try with 0 as 4th parameter (exact match).
- It seems provide the last answer it find if without 4th parameter.
- tried =IF(B18="","",VLOOKUP($B18,Price12521,2)0) and it corrects it to =IF(B18="","",VLOOKUP($B18,Price12521,2)*0) and then i get a value error with the formula. unless im putting it in the wrong spot.
- =IF(B18="","",VLOOKUP($B18,Price12521,2,0))
