Forum Discussion
jdnien2021
Jan 19, 2022Copper Contributor
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...
jdnien2021
Jan 19, 2022Copper Contributor
scratch that i figured it out so they are both the same either text or number
SergeiBaklan
Jan 19, 2022Diamond Contributor
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)
- jdnien2021Jan 19, 2022Copper Contributordont know why my pictures arnt showing up but i did that on both sheets
- jdnien2021Jan 19, 2022Copper Contributor