Tech Support Guy banner
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
7 Posts
Discussion Starter · #1 ·
Respected All,

My doubt regarding vlookup function I just want match 2 cell. Both cell contain numeric cells. When I vlookup both cell showing Not applicable error. When I check both cell with "Is number " function one cell showing True & other cell showing False. I think one cell may be contain text format. Can I know any solution to change text formula to number formula. Please help me.
 

·
Super Moderator
Joined
·
65,526 Posts
do a text to columns - that will change the text number to a real number
also try a formula in another cell - cell + 1
can you attach a sample sheet
 

·
Super Moderator
Joined
·
65,526 Posts
2nd option is just to see if the cell value is formatted as text or a value
can we see a sample
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top