View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlm xlm is offline
external usenet poster
 
Posts: 55
Default If formula help needed

try this formula in D2 and copy down as far as your data range is.

=INDEX(Sheet2!A:A,MATCH(Sheet1!A2&TEXT(Sheet1!C2," ????0"),Sheet2!$B$2:$B$5&TEXT(Sheet2!$C$2:$C$5,"?? ??0"))+1)

Let me know if this do what you want?

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Belinda7237" wrote:

Sheet 1:

customer rating transaction amount Approval Level Required
6 $10,000


Sheet 2
Approval Authority customer rating trans $
assoc. 6 $1,000
assoc. + mgr 6 $3,000
Exec 6 $5,000
Assoc. + Exec 6 $15,000


On sheet 1 the customer rating is 6(column A) and the transaction amount is
10,000 (column c) and in column D I want to return a value from the look up
table for an approval requirement.

On sheet 2
in column A i have the approval value that i need to input into sheet 1
It will no what row i need by matching column B on sheet 2 which is the
customer rating and column C which is the tranaction amount.

In this example the rating is 6 and the transaction amount is 10,000 - the
values in the lookup table go from 5000 on row 3 to 15000 on row 4 so 10000
would need to look at the 15000 level and provide the answer that matches the
15000 which is Assoc +Exec.