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.

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


"Elaine0203" wrote in message
...
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.

Thank you for your help.



"Bernie Deitrick" wrote:

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


"Elaine0203" wrote in message
...
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.


.