Please Help!

E

Elaine0203

Hi, hopefully someone can help me with this as I have drawn a blank. I have
the following rental costs options on excel
A B C D
E
1 Street Monthly Quarterly Annual Cost
2 High St Y
3 Main St Y
4 Church St Y

If I have the a reference sheet with st names and the rental costs in
columns F (st names) G (monthly cost) H (quarterly cost) I (annual cost)
What formula can I use to get column E to "Pick" the correct Street and
costing from this data list?

Thanks in advance for your help.
 
B

Bernie Deitrick

Enter this in cell B2:

=VLOOKUP($A2,'Reference Sheet Name'!$F:$I,COLUMN(),FALSE)

Then copy and paste to create your table.

HTH,
Bernie
MS Excel MVP
 
E

Elaine0203

Thank you for your help.



Bernie Deitrick said:
Enter this in cell B2:

=VLOOKUP($A2,'Reference Sheet Name'!$F:$I,COLUMN(),FALSE)

Then copy and paste to create your table.

HTH,
Bernie
MS Excel MVP





.
 

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

Please help! 4
Centralized data 3
please help 0
relective formula 0
help w indirect and index,match 3
Formula Help - Urgent 0
Text and Numeric lookup 5
Query 1

Top