Excel Data calling

K

Kaya

Hi all, I'm new here but am hoping you can help me please! :)

in one sheet I have a list of days and payments that corospond to the days

the other sheet is "On call Payments" I need to be able to enter a day then
have the payment from the first sheet appear in the payment coloumn on the
"On call Payments" ??

Hopw you understand and can help

Thanks

** Confused**
Kaya
 
A

Alex Delamain

Ok, assuming your data is on sheet 1, with column a holding the date an
column B holding the payment

on sheet 2 say you enter the date in B2

the formula you need should then be

=vlookup(b2,Sheet1!A1:B10,2
 
Top