Vlookup returning a text value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the data both being in same excel sheet(Sales) but different tabs. Tab1 and Tab2 being two diff. tabs in a excel workshee

Tab1 Tab

Order# Status Order# Statu
723 Ship 723 ______
456 Not started 45
123 Cancelled 123

I want to write a v-lookup on Tab 2 to look up Order# 723 and return the text value of Ship from Tab 1

How do I do this? It keeps coming back 0 or N/A#
 
What is this TAB you refer to? These are workSHEETS within a workBOOK?

try

=index(tab1!b$1:b$3,match(a1,tab1!a$1:a$3))



Brian said:
Here is the data both being in same excel sheet(Sales) but different tabs.
Click to expand...
Tab1 and Tab2 being two diff. tabs in a excel worksheet
 
Forgot a ",0"

=index(tab1!b$1:b$3,match(a1,tab1!a$1:a$3,0))

Brian said:
Here is the data both being in same excel sheet(Sales) but different tabs.
Click to expand...
Tab1 and Tab2 being two diff. tabs in a excel worksheet
 
Hi

When the first table is in range A1:B100 (A1:B1 is header) and second table
in columns F:G (F1:G1 is header), then for G2 the formula is
=VLOOKUP(F2,$A$2:$B$100,2,FALSE)

When the formula anyway returns N/#A, then probably Oredr# fields in tables
don't match. You can check this comparing 2 cells with visible same values.
P.e. when you see in cells A2 and F2 723, then enter into some free cell the
formula
=(A2=F2)
When the result is false, then you have to check your data. Maybe one is
number and another text. Or they are both numbers, but they differ in
decimals and cells are formatted to show only the integer part. Or they are
both texts, but one has some leading/trailing spaces.

--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


Brian said:
Here is the data both being in same excel sheet(Sales) but different tabs.
Click to expand...
Tab1 and Tab2 being two diff. tabs in a excel worksheet
 
Back
Top