VLOOKUP help

  • Thread starter Thread starter robertuva
  • Start date Start date
R

robertuva

I have the following worksheets:

IAN
OneTravel

I have the following headers:

IAN:
PropertyID PropertyName Address1 City State Country ZipCode ONEIAN

OneTravel:
PropertyID PropertyName Address1 City State Country ZipCode ONECON

These are from columns A:H. I am trying to do a lookup in IAN (column
I) that use the ONEIAN column and lookup to find a match in the ONECON
column in the OneTravel worksheet and send back the PropertyID column
value from the OneTravel worksheet.

I tried this:

=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

It didn't work. Help! I have attached a sample.


+----------------------------------------------------------------+
| Attachment filename: hotelsummary3.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371707|
+----------------------------------------------------------------+
 
I took a look at your attachment and I do not see an "I20864" anywhere.
What does this reference?

--
Laura Cook
Appleton, WI


robertuva said:
I have the following worksheets:

IAN
OneTravel

I have the following headers:

IAN:
PropertyID PropertyName Address1 City State Country ZipCode ONEIAN

OneTravel:
PropertyID PropertyName Address1 City State Country ZipCode ONECON

These are from columns A:H. I am trying to do a lookup in IAN (column
I) that use the ONEIAN column and lookup to find a match in the ONECON
column in the OneTravel worksheet and send back the PropertyID column
value from the OneTravel worksheet.

I tried this:

=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

It didn't work. Help! I have attached a sample.


+----------------------------------------------------------------+
| Attachment filename: hotelsummary3.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371707|
+----------------------------------------------------------------+

------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
I'm a little surprised that you've decided to double post this .... not
likely you'll get an answer any quicker.

robertuva said:
I have the following worksheets:

IAN
OneTravel

I have the following headers:

IAN:
PropertyID PropertyName Address1 City State Country ZipCode ONEIAN

OneTravel:
PropertyID PropertyName Address1 City State Country ZipCode ONECON

These are from columns A:H. I am trying to do a lookup in IAN (column
I) that use the ONEIAN column and lookup to find a match in the ONECON
column in the OneTravel worksheet and send back the PropertyID column
value from the OneTravel worksheet.

I tried this:

=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

It didn't work. Help! I have attached a sample.


+----------------------------------------------------------------+
| Attachment filename: hotelsummary3.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371707|
+----------------------------------------------------------------+

------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
robert,

Where did the leading "I" come from?
=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)
Click to expand...
On your "OneTravel" sheet, column "A" is all numbers.
Tried your formula with a valid number from the "OneTravel"
sheet and it worked fine.
Example:
=VLOOKUP(54479,OneTravel!A1:H31814,1,0)

John

robertuva said:
I have the following worksheets:

IAN
OneTravel

I have the following headers:

IAN:
PropertyID PropertyName Address1 City State Country ZipCode ONEIAN

OneTravel:
PropertyID PropertyName Address1 City State Country ZipCode ONECON

These are from columns A:H. I am trying to do a lookup in IAN (column
I) that use the ONEIAN column and lookup to find a match in the ONECON
column in the OneTravel worksheet and send back the PropertyID column
value from the OneTravel worksheet.

I tried this:

=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

It didn't work. Help! I have attached a sample.


+----------------------------------------------------------------+
| Attachment filename: hotelsummary3.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371707|
+----------------------------------------------------------------+

------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
I am basically trying to match up values and bring it back if it matches
between the two worksheets. The last formula doesn't do that. It just
pulls from where a value is exactly that. I need the Values in column
H to matchup, and if they do, bring back the value from column A and
put it on one of the worksheets. Therefore, matches to column H will
give me the variables from both column As in the same worksheet.
 
=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

The I20864 looks up in the first column of the table, i.e.
in column A of the OneTravel worksheet. To get around this
u can insert a column on the left of the OneTravel table
and link it to the H cell (now I after inserting the new
column) in the same row.

After this u need to change the column to lookup from 1 to
2.

Hope this helps

G


-----Original Message-----

I have the following worksheets:

IAN
OneTravel

I have the following headers:

IAN:
PropertyID PropertyName Address1 City State Country ZipCode ONEIAN

OneTravel:
PropertyID PropertyName Address1 City State Country ZipCode ONECON

These are from columns A:H. I am trying to do a lookup in IAN (column
I) that use the ONEIAN column and lookup to find a match in the ONECON
column in the OneTravel worksheet and send back the PropertyID column
value from the OneTravel worksheet.

I tried this:

=VLOOKUP(I20864,OneTravel!A1:H31814,1,0)

It didn't work. Help! I have attached a sample.


+------------------------------------------------------ ----------+
| Attachment filename:
Click to expand...
hotelsummary3.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=371707|
----------+

------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
Back
Top