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 where it pulls from. i also included my formula that has worked upto this point.
14 Replies
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
- scratch that i figured it out so they are both the same either text or number
How do you know?
For the first table you may enter into A32
=ISTEXT(B32)
For the second one find empty cell and enter into it =ISTEXT(A17)
- where do i use the ISTEXT?
