LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Question regarding VLookup and if it can check two columns of data

Hi,

My experience with any excel formulas is very limited and I was just
wondering if someone could provide me with a formula / and or help with my
current problem.

I have two sheets in the same workbook and would like to return data from
column 3 in sheet 1 to column 3 in sheet 2. However, i don't know if Vlookup
can check two columns of data (text) in sheet 1 with two columns in sheet 2.

Example below: (Imagine | as the divider between columns)

Sheet 1:
A | B | C
Make 1 | Model1 | 2000
Make 2 | Model1 | 1000 / 1002
Make 3 | Model3 | 1003

Sheet2:
A | B | C
Make 7 | Model5 | N/A
Make 1 | Model1 | 2000
Make 3 | Model3 | 1003

So as you can see above, I'd like it to check Make AND Model in sheet two
with sheet one and return the value in column C in sheet 1 to column C in
sheet 2.

Any help with this would be great.

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP, columns question / different way? nastech Excel Discussion (Misc queries) 2 September 5th 07 01:04 PM
Question about using VLOOKUP with Data validation ralphdevlin via OfficeKB.com Excel Worksheet Functions 1 October 12th 06 04:39 AM
Question about Data-Text to Columns command [email protected] Excel Discussion (Misc queries) 2 April 27th 06 09:10 PM
Using VLOOKUP to draw data from two columns Dan Excel Discussion (Misc queries) 5 June 25th 05 12:29 PM
Vlookup against multiple columns/worksheets question JCarter Excel Discussion (Misc queries) 8 March 9th 05 04:59 PM


All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"