Help With Match Function

R

RudeRam

I am inputting names on one worksheet and I need them to populate
another work sheet but with more info that is obtained from a table on
the same second worksheet .

I have tried using the following formula with no results,
=IF(B6='Schedule Build'!G2,Then MATCH(0,B78:D116,0))

TI
 
D

Dave O

Part of your difficulty is your syntax: "THEN" does not appear in an
IF() function.

Nested INDEX() and MATCH() functions may work for you. Using American
coins as an example, populate a blank sprdsht like this:
a1 penny
a2 nickel
a3 dime
a4 quarter

b1 .01
b2 .05
b3 .1
b4 .25

d1 penny
d2 nickel
d3 dime
d4 quarter

In cell e1, enter this formula:
=INDEX($A$1:$B$4,MATCH(D1,$A$1:$A$4,0),2)
This function matches the entry in column D to the entry in column A,
and returns the associated value from column B. This will work for
matching names ONLY if the names are spelled exactly the same.
 
R

RudeRam

Let me if I can restate my problem here:
I have one worksheet that is the schedule, that I input names into. O
a second worksheet, I have a sign out sheet that I need the names fro
worksheet 1 inputted. Along with that there is addtional informatio
from a table on work sheet 2 inputted into the adjacent cells.


I used the following formula:

=IF(B6='Schedule Build'!$G$2$)(HLOOKUP,Names,'FL
AUTH'!B77:E116,FALSE))

When I hit enter to end the formula I get the formula contains an erro
and when I hit ok the $G2$ is highlighted.

I could use any help on this

Thank
 
D

Dave Peterson

You lost a comma, added an extra $ ($g$2, not $g$2$).

Maybe...

=IF(B6='Schedule build'!$G$2,HLOOKUP(Names,'flt auth'!B77:E116,FALSE),"")

but I don't know what Names is either.
 
R

RudeRam

Dave,

Thanks for the input. Names is the table per say on the 2nd workshee
that draws additional information that I need. I was reading on/in
board or a help book that if you put info into a table that it would b
easier for excel to look up the info.

Ric
 
D

Dave Peterson

I'm not sure it makes too much of a difference to excel, but using a range name
should make it lots easier for you. You don't have to worry about
relative/absolute addressing (for one thing).
 
Top