Vlookup

B

bluenoser13

Hello:

Thanks you for your reply. I will try them to see which works best fo
me. :
 
D

Domenic

bluenoser13 said:
Hello:

Thanks you for your reply. I will try them to see which works best fo
me. :)
Click to expand...

Actually, if you prefer, you can combine my two formulas into one...

Sheet1!C2:

=IF(A2<>13,INDEX(Sheet2!B2:G6,B2,A2),SUM(INDEX(Sheet2!B2:G6,B2,0))
 

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

Similar Threads

Multiple VLOOKUP in an IF statement 2
Copy values for every nth cell 7
Have 4 email addresses Want to auto forward all in one of them 0
INDEX_MATCH or VLOOKUP with multiple criteria? 4
Vlookup 1
If then formula with multiple Ifs 3
Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
If or VLookup function 0

Top