information from Col A:A

S

Steved

Hello from Steved

I've got 2 worksheets

The sheets are called "Duties Mon-Fri" and "Mon-Fri"

=IF(ISNA(VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,VLOOKUP($B$2:$C$2,'Duties
Mon-Fri'!$C$2:$E$4994,3,FALSE))

The above works perfectly because I copied the information into Col E:E

Question please How do I get the information from Col A:A

I Thankyou.
 
D

Dave Peterson

I would think that you'd only use a single cell as that first parm's value:

=IF(ISNA(VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,
VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE))

But if you want to bring back the value in column and match the value in column
B:

=index('duties mon-fri'!$a$2:$a4994,match($b$2,'duties
mon-fri'!$b$2:$b$4994,0)))

You may want to check for an error first:
=if(isna(match($b$2,'duties mon-fri'!$b$2:$b$4994,0)),0,....

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble
 
S

Steved

Thankyou

Dave Peterson said:
I would think that you'd only use a single cell as that first parm's value:

=IF(ISNA(VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE)),0,
VLOOKUP($B$2,'Duties Mon-Fri'!$C$2:$E$4994,3,FALSE))

But if you want to bring back the value in column and match the value in column
B:

=index('duties mon-fri'!$a$2:$a4994,match($b$2,'duties
mon-fri'!$b$2:$b$4994,0)))

You may want to check for an error first:
=if(isna(match($b$2,'duties mon-fri'!$b$2:$b$4994,0)),0,....

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top