hi, im looking to compare to cells and return a 3rd

viste

New Member
Joined
Feb 23, 2011
Messages
2
Hi, guys this is, my 1st post.

what im looking to do is compare to cells and return a third. example
i know this is wrong because it dosent work but its the best way i can think of to explain it

=Vlookup(name and date,A:B,2,true) i just cant get my head around it..
hope this makes sense . appreciate any help i can get thanks


 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hi, guys this is, my 1st post.

what im looking to do is compare to cells and return a third. example
i know this is wrong because it dosent work but its the best way i can think of to explain it

=Vlookup(name and date,A:B,2,true) i just cant get my head around it..
hope this makes sense . appreciate any help i can get thanks


Try to post a few records from A:B along with the desired result.
 
Upvote 0
Try to post a few records from A:B along with the desired result.

thanks :)

1.JPG
2.JPG
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,584
Messages
6,179,691
Members
452,938
Latest member
babeneker

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