Posts by bagofmilk

I have a table as such

[TABLE="width: 500"]

[tr]

[td]

PARTNO

[/td]

[td]

VOLTAGE

[/td]

[td]

FLA

[/td]

[/tr]

[tr]

[td]

P0153

[/td]

[td]

208

[/td]

[td]

3.3

[/td]

[/tr]

[tr]

[td]

P0634

[/td]

[td]

208

[/td]

[td]

4.5

[/td]

[/tr]

[tr]

[td]

P0783

[/td]

[td]

208

[/td]

[td]

6.1

[/td]

[/tr]

[tr]

[td]

P0153

[/td]

[td]

460

[/td]

[td]

1.5

[/td]

[/tr]

[tr]

[td]

P0634

[/td]

[td]

460

[/td]

[td]

2.1

[/td]

[/tr]

[tr]

[td]

P0783

[/td]

[td]

460

[/td]

[td]

2.8

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

Notice that there are duplicates in the PARTNO column. I need to do a VLOOKUP that matches the PARTNO and VOLTAGE, then returns the FLA

Example: Find the FLA where PARTNO="P0634" and VOLTAGE=460 ---> RETURNS: FLA = 2.1

Or maybe there is another method instead of VLOOKUP?

*EDIT* A VBA Approach is also acceptable