# Vlookup help

#### howard

##### Well-known Member
I have used the following Vlookup formula to look up a description

=IF(ISTEXT(B1096),VLOOKUP(B1096+0,TBTXT!B:E,2,FALSE),VLOOKUP(B1096,TBTXT!B:E,2,FALSE))

This formula works well if the value in B1096 is say 199992 . However, if an X or K appears first for ex X10196, then I get #value!

I have attached some sample data. Your assistance in resolving this is most appreciated

Excel Workbook
BC
1095199940Dividends Paid
1096199992Transfer To Balance Sheet
1097X13040#VALUE!
1098X13060#VALUE!
1099X13080#VALUE!
1100X13100#VALUE!
TB Consolidation

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Could you also share "TBTXT" sheet, I will re-create the Excel formula accordingly. Thanks!

Hi

=VLOOKUP(IF(ISNUMBER(B1096+0),B1096+0,B1096),TBTXT!B:E,2,FALSE)

Thanks for the help, much appreciated

Some sample data from "TBTXT"

Excel Workbook
BC
1174199916Coy Tax - Deferred
1175199930Goodwill W/off
1176199940Dividends Paid
1177199992Transfer To Balance Sheet
1178X11300New Vehicle Stock Units
1179X11302N/V Inv Units 0-30
1180X11304N/V Inv Units 31-60 Days
1181X11306N/V Inv Units 61-90
1182X11308N/V Inv Units >90days
1183X11320N/V Inv Value 0-30
1184X11322N/V Inv Value 31-60
1185X11324N/V Inv Value 61-90
1186X11326N/V Inv Value >90
TBTXT

Hi

=VLOOKUP(IF(ISNUMBER(B1096+0),B1096+0,B1096),TBTXT!B:E,2,FALSE)

Did my suggestion work for you?

Thanks, Your suggestion worked 100% for me

Excellent! Thanks for letting me know

Replies
3
Views
309
Replies
10
Views
679
Replies
1
Views
98
Replies
2
Views
205
Replies
0
Views
119

1,207,260
Messages
6,077,351
Members
446,279
Latest member
hoangquan2310

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back