Formula Question

rgolf

New Member
Joined
Feb 11, 2005
Messages
1
Hello all,

Any help with this would be appreciated. I recently started trying to truley use Excel and and love some of the things I have been able to do. I currently am stumped however. I recently created a formula

=VLOOKUP(B2,Status,2,FALSE)

It works great if I type data into cell B2 but it doesnt if i import data to that cell. Any ideas ?

Probably a silly question, but i have searched and searched and cant find an answer

Thank You
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
rgolf said:
Hello all,

Any help with this would be appreciated. I recently started trying to truley use Excel and and love some of the things I have been able to do. I currently am stumped however. I recently created a formula

=VLOOKUP(B2,Status,2,FALSE)

It works great if I type data into cell B2 but it doesnt if i import data to that cell. Any ideas ?

Probably a silly question, but i have searched and searched and cant find an answer

Thank You

Looks like the data type B2 and that of the first colomn in Status do not agree. Try to align them qua data type.
 
Upvote 0

Forum statistics

Threads
1,203,752
Messages
6,057,151
Members
444,908
Latest member
Jayrey

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top